THE PLATFORM

The FINRA Transparency Services is responsible for the collection, management and dissemination of data at FINRA. We are building a new system to collect and process millions of records (up to 100 million) each day in support of FINRA's regulatory mission to protect investors and promote market integrity. We are embarking upon a large, multi-year, enterprise-wide initiative for a new stream of data with highly customer-centric products and capabilities.
THE ROLE
Mid Big Data Developer
Are you passionate in data? Do you like working in a challenging environment where massive volume of data is ingested and processed every day? Are you a continuous learner who wants to learn new tools and technologies in evolving big data and data science technology? Do you have passion in detecting data anomalies in large datasets? Do you expect the best from yourself and those around you? FINRA is looking for you.

We are looking for big data developers for ETL project in our enterprise Transparency Services group. Big data developer will work on ingesting, storing, validating and disseminating after transforming data in a consumable format for business intelligence teams and data analysts to get deeper business insight from the data.

Job Responsibilities

• Understand complex business requirements
• Design and develop ETL pipeline for collecting, validating and transforming data according to the specification
• Develop automated unit tests, functional tests and performance tests
• Maintain optimal data pipeline architecture
• Design ETL jobs for optimal execution in AWS cloud environment
• Reduce processing time and cost of ETL workloads
• Participate in peer reviews and design/code review meetings
• Provide support for production support operations team
• Implement data quality checks.
• Identify areas where machine learning can be used to identify data anomalies

Experience & Qualifications

• 5 years of experience in programming language Java or Scala
• 5 years of experience in ETL projects
• 3 years of experience in big data projects
• 2 years of experience with API development (REST API's) and testing (Rest Assured)
• Believes in Scrum/Agile, and has deep experience delivering software when working on teams that use Scrum/Agile methodology
• Strong and creative analytical and problem-solving skills

Required Technical Skills & Knowledge

• Strong experience in Java or Scala
• Strong experience in big data technologies like AWS EMR, AWS EKS, Apache Spark
• Strong experience with serverless technologies like AWS Dynamo DB, AWS Lambda
• Strong experience in processing with JSON files
• Must be able to write complex SQL queries
• Experience in performance tuning and optimization
• Familiar with columnar storage formats (ORC, Parquet) and various compression techniques
• Experience in writing Unix shell scripts
• Unit testing using JUnit or ScalaTest
• Git/Maven/Gradle
• Code Reviews
• Agile

The following skills a plus:

• AWS Cloud
• BPM/AWS Step Functions
• Python scripting
• Foundational knowledge of application security testing
• Hands-on DevOps skills
• UI testing tools like Cypress, Playwright

#LI-MK4
#Dice